﻿<?xml version="1.0"?>
<ConfigList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Lists>
    
    <ListInfo  ListKey="SqlConfig" ListDesc="页面sql语句">
      <Items>
        <ItemInfo name="Insert" value="INSERT INTO [dbo].[UKNOW_MEMBER_INFO]
           ([USERNAME]
           ,[PASSWORD]
           ,[MEMBER_NAME]
           ,[USER_TYPE]
           ,[MOBLIE]
           ,[Register_TIME]
           , [RegisterType]
           ,[STATE]
           ,[EMAIL]
           ,[BIRTHDAY]
           ,[StudyAbroad]
           ,[IELTS]
           ,[ArtsAndCulture]
           ,[Sina]
           ,[Sohu]
           ,[Tengxun]
           ,[SinaWeibo]
           ,[TengXunWeibo]
           ,[Kaixin]
           ,[Douban]
           ,[Renren]
           ,[Google]
           ,[Baidu]
           ,[Bing]
           ,[OfflineEvents]
           ,[Newspaper] 		
           ,[Outdoor] 			
           ,[Taxi] 					
           ,[Metro]					
           ,[BBS] 					
           ,[TV] 						
           ,[Recommendtion]
           ,
            [OtherChannels])
     VALUES
           (
           '[$USERNAME]'
           ,'[$PASSWORD]'
           ,'[$MEMBER_NAME]'
           ,[$USER_TYPE]
           ,'[$MOBLIE]'
           ,'[$Register_TIME]'
           ,'[$RegisterType]'
           ,[$STATE]
           ,'[$EMAIL]'
           ,[$BIRTHDAY]
           ,'[$StudyAbroad]'
           ,'[$IELTS]'
           ,'[$ArtsAndCulture]'
           ,'[$Sina]'
           ,'[$Sohu]'
           ,'[$Tengxun]'
           ,'[$SinaWeibo]'
           ,'[$TengXunWeibo]'
           ,'[$Kaixin]'
           ,'[$Douban]'
           ,'[$Renren]'
           ,'[$Google]'
           ,'[$Baidu]'
           ,'[$Bing]'
           ,'[$OfflineEvents]'
           ,'[$Newspaper]' 		
           ,'[$Outdoor]' 			
           ,'[$Taxi]' 					
           ,'[$Metro]'					
           ,'[$BBS]' 					
           ,'[$TV]' 						
           ,'[$Recommendtion]'
           ,
            '[$OtherChannels]'
                  
           )
           "/>
        <ItemInfo name="SelectByUserName" value="select username from dbo.UKNOW_MEMBER_INFO where USERNAME='[$USERNAME]' and state=0"/>
        <ItemInfo name="SelectByMail" value="select EMAIL from dbo.UKNOW_MEMBER_INFO where EMAIL='[$EMAIL]' and state=0"/>
        <ItemInfo name="ContactInsert" value="INSERT INTO [dbo].[UKNOW_Contact_INFO]
           ([USERNAME]
           ,[USER_TYPE]
           ,[MOBLIE]
           ,[Register_TIME]
           ,[STATE]
           ,[EMAIL]
           ,[BIRTHDAY]
           ,[NATURE]
          )
     VALUES
           (
           '[$USERNAME]'
           ,[$USER_TYPE]
           ,'[$MOBLIE]'
           ,'[$Register_TIME]'
           ,[$STATE]
           ,'[$EMAIL]'
           ,[$BIRTHDAY]
           ,'[$NATURE]'
           )
           "/>
        <ItemInfo name="ContactByUserName" value="select username from dbo.UKNOW_Contact_INFO where USERNAME='[$USERNAME]' and state=0"/>
        <ItemInfo name="ContactByMail" value="select EMAIL from dbo.UKNOW_Contact_INFO where EMAIL='[$EMAIL]' and state=0"/>
      </Items>
      
    </ListInfo>
  </Lists>
</ConfigList>
